|
Book details / order |
ORACLE 11I DATABASE SQL EXPERT CERTIFICATION GUIDE |
About the book
the ucertify-tata mcgraw hill professional: certification series intends to help readers succeed at it certification examinations. it helps students attain better understanding of the examination objectives and procedures,and also enables easy recall of the key concepts. each book in this series is an indispensable resource that would help students perform well in the respective examinations.
this book covers the important topics of the oracle 1z0-047 examination in a comprehensive yet concise manner. the book:
provides focused review of study material to save crucial preparation time
highlights important concepts with pop quizzes
contains chapter-end questions for better comprehension and a full-length practice test with answers and explanations to determine examination readiness
this book will prove invaluable for it professionals aspiring for the oracle database sql expert certification.
the cd-rom contains:
ucertify's test preparation software?the ucertify prepkit-for oracle database sql expert certification
question bank consisting of over 200 questions
study aids such as flash cards, study notes, and tagging.
about the author
ucertify
founded in 1996, ucertify is a leading provider of examination preparation solutions for over 300 it certification examinations. ucertify products provide a comprehensive examination preparation solution with full objective coverage, realistic practice tests, comprehensive study notes, and supplemental reference material to help candidates pass their certification examinations.
our material is authored by professionals experienced in the field. their experience and expertise is shared in an easy to understand format, by way of comprehensive examination simulations, practice tests, detailed answer explanations, and technical articles.
ucertify is a fast-growing company, with offices in the us and india, and customers in over 200 countries. the continuously growing range of ucertify products include examination simulation prepkits and collections (a collection of related prepkits for a specific certification) for over 300 it certifications, including mcse 2003, mcsa, mcdba, mcad, oca, ocp, a+, network+, security+, ciw associate, ciw professional, and scjp.
table of contents
1. retrieving data using the sql select statement
2. restricting and sorting data
3. using single-row functions to customize output
4. reporting aggregated data using the group functions
5. displaying data from multiple tables
6. using subqueries to solve queries
7. using the set operators
8. manipulating data
9. using ddl statements to create and manage tables
10. creating other schema objects
11. managing objects with data dictionary views
12. controlling user access
13. managing schema objects
14. manipulating large data sets
15. generating reports by grouping related data
16. managing data in different time zones
17. retrieving data using subqueries
18. hierarchical retrieval
19. regular expression support.
Author : Ucertify
Publication : Tata
Isbn : 9780071078443
Store book number : 106
NRS 360.00
|
|
|
|
|
|
|
|
|
|